Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 16610 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 160.0 B |
Variable types
| NUM | 19 |
|---|---|
| BOOL | 1 |
Reproduction
| Analysis started | 2020-06-23 21:30:19.721728 |
|---|---|
| Analysis finished | 2020-06-23 21:32:06.868181 |
| Duration | 1 minute and 47.15 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
df_index has unique values | Unique |
view has 14914 (89.8%) zeros | Zeros |
sqft_basement has 9959 (60.0%) zeros | Zeros |
yr_renovated has 15863 (95.5%) zeros | Zeros |
| Distinct count | 16610 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8306.098254063818 |
|---|---|
| Minimum | 0 |
| Maximum | 16612 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 830.45 |
| Q1 | 4153.25 |
| median | 8306.5 |
| Q3 | 12458.75 |
| 95-th percentile | 15781.55 |
| Maximum | 16612 |
| Range | 16612 |
| Interquartile range (IQR) | 8305.5 |
Descriptive statistics
| Standard deviation | 4795.840442 |
|---|---|
| Coefficient of variation (CV) | 0.5773878776 |
| Kurtosis | -1.199873842 |
| Mean | 8306.098254 |
| Median Absolute Deviation (MAD) | 4153 |
| Skewness | -0.0001451354083 |
| Sum | 137964292 |
| Variance | 23000085.55 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 8817 | 1 | < 0.1% | |
| 4775 | 1 | < 0.1% | |
| 6822 | 1 | < 0.1% | |
| 677 | 1 | < 0.1% | |
| 2724 | 1 | < 0.1% | |
| 12963 | 1 | < 0.1% | |
| 15010 | 1 | < 0.1% | |
| 8865 | 1 | < 0.1% | |
| 10912 | 1 | < 0.1% | |
| Other values (16600) | 16600 | 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 16612 | 1 | < 0.1% | |
| 16611 | 1 | < 0.1% | |
| 16610 | 1 | < 0.1% | |
| 16609 | 1 | < 0.1% | |
| 16608 | 1 | < 0.1% |
price
Real number (ℝ≥0)
| Distinct count | 3298 |
|---|---|
| Unique (%) | 19.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 533528.465141481 |
|---|---|
| Minimum | 75000.0 |
| Maximum | 7700000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 75000 |
|---|---|
| 5-th percentile | 209680 |
| Q1 | 315000 |
| median | 447000 |
| Q3 | 638925 |
| 95-th percentile | 1145000 |
| Maximum | 7700000 |
| Range | 7625000 |
| Interquartile range (IQR) | 323925 |
Descriptive statistics
| Standard deviation | 366543.1737 |
|---|---|
| Coefficient of variation (CV) | 0.6870170903 |
| Kurtosis | 40.8661537 |
| Mean | 533528.4651 |
| Median Absolute Deviation (MAD) | 152000 |
| Skewness | 4.319542239 |
| Sum | 8861907806 |
| Variance | 1.343538982e+11 |
| Value | Count | Frequency (%) | |
| 350000 | 147 | 0.9% | |
| 450000 | 133 | 0.8% | |
| 550000 | 118 | 0.7% | |
| 500000 | 115 | 0.7% | |
| 325000 | 114 | 0.7% | |
| 400000 | 110 | 0.7% | |
| 375000 | 108 | 0.7% | |
| 250000 | 108 | 0.7% | |
| 525000 | 106 | 0.6% | |
| 425000 | 106 | 0.6% | |
| Other values (3288) | 15445 | 93.0% |
| Value | Count | Frequency (%) | |
| 75000 | 1 | < 0.1% | |
| 78000 | 1 | < 0.1% | |
| 80000 | 1 | < 0.1% | |
| 81000 | 1 | < 0.1% | |
| 82000 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7700000 | 1 | < 0.1% | |
| 7062500 | 1 | < 0.1% | |
| 6885000 | 1 | < 0.1% | |
| 5570000 | 1 | < 0.1% | |
| 5350000 | 1 | < 0.1% |
bedrooms
Real number (ℝ≥0)
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.3659843467790487 |
|---|---|
| Minimum | 0 |
| Maximum | 33 |
| Zeros | 11 |
| Zeros (%) | 0.1% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.937192558 |
|---|---|
| Coefficient of variation (CV) | 0.2784304564 |
| Kurtosis | 61.5292295 |
| Mean | 3.365984347 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.385437079 |
| Sum | 55909 |
| Variance | 0.8783298908 |
| Value | Count | Frequency (%) | |
| 3 | 7607 | 45.8% | |
| 4 | 5256 | 31.6% | |
| 2 | 2123 | 12.8% | |
| 5 | 1184 | 7.1% | |
| 6 | 223 | 1.3% | |
| 1 | 156 | 0.9% | |
| 7 | 32 | 0.2% | |
| 0 | 11 | 0.1% | |
| 8 | 10 | 0.1% | |
| 9 | 4 | < 0.1% | |
| Other values (3) | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 11 | 0.1% | |
| 1 | 156 | 0.9% | |
| 2 | 2123 | 12.8% | |
| 3 | 7607 | 45.8% | |
| 4 | 5256 | 31.6% |
| Value | Count | Frequency (%) | |
| 33 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 2 | < 0.1% | |
| 9 | 4 | < 0.1% | |
| 8 | 10 | 0.1% |
bathrooms
Real number (ℝ≥0)
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.062086092715232 |
|---|---|
| Minimum | 0.0 |
| Maximum | 8.0 |
| Zeros | 9 |
| Zeros (%) | 0.1% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.5 |
| median | 2 |
| Q3 | 2.5 |
| 95-th percentile | 3.3875 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7588425967 |
|---|---|
| Coefficient of variation (CV) | 0.3679975339 |
| Kurtosis | 1.465347347 |
| Mean | 2.062086093 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.5597552469 |
| Sum | 34251.25 |
| Variance | 0.5758420866 |
| Value | Count | Frequency (%) | |
| 2.5 | 3870 | 23.3% | |
| 1 | 3216 | 19.4% | |
| 1.75 | 2533 | 15.2% | |
| 2.25 | 1573 | 9.5% | |
| 2 | 1561 | 9.4% | |
| 1.5 | 1149 | 6.9% | |
| 2.75 | 875 | 5.3% | |
| 3 | 549 | 3.3% | |
| 3.5 | 449 | 2.7% | |
| 3.25 | 381 | 2.3% | |
| Other values (19) | 454 | 2.7% |
| Value | Count | Frequency (%) | |
| 0 | 9 | 0.1% | |
| 0.5 | 4 | < 0.1% | |
| 0.75 | 55 | 0.3% | |
| 1 | 3216 | 19.4% | |
| 1.25 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7.75 | 1 | < 0.1% | |
| 7.5 | 1 | < 0.1% | |
| 6.75 | 2 | < 0.1% | |
| 6.25 | 1 | < 0.1% |
sqft_living
Real number (ℝ≥0)
| Distinct count | 787 |
|---|---|
| Unique (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2053.884105960265 |
|---|---|
| Minimum | 370 |
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 930 |
| Q1 | 1415.5 |
| median | 1899.5 |
| Q3 | 2500 |
| 95-th percentile | 3720 |
| Maximum | 13540 |
| Range | 13170 |
| Interquartile range (IQR) | 1084.5 |
Descriptive statistics
| Standard deviation | 904.4817744 |
|---|---|
| Coefficient of variation (CV) | 0.440376247 |
| Kurtosis | 6.377088606 |
| Mean | 2053.884106 |
| Median Absolute Deviation (MAD) | 529.5 |
| Skewness | 1.574624776 |
| Sum | 34115015 |
| Variance | 818087.2803 |
| Value | Count | Frequency (%) | |
| 1400 | 110 | 0.7% | |
| 1300 | 109 | 0.7% | |
| 1560 | 107 | 0.6% | |
| 1010 | 105 | 0.6% | |
| 1720 | 104 | 0.6% | |
| 1440 | 102 | 0.6% | |
| 1660 | 100 | 0.6% | |
| 1250 | 100 | 0.6% | |
| 1820 | 99 | 0.6% | |
| 1480 | 99 | 0.6% | |
| Other values (777) | 15575 | 93.8% |
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13540 | 1 | < 0.1% | |
| 12050 | 1 | < 0.1% | |
| 10040 | 1 | < 0.1% | |
| 9890 | 1 | < 0.1% | |
| 9640 | 1 | < 0.1% |
sqft_lot
Real number (ℝ≥0)
| Distinct count | 8064 |
|---|---|
| Unique (%) | 48.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15739.596929560506 |
|---|---|
| Minimum | 520 |
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 2800 |
| Q1 | 5455 |
| median | 7902.5 |
| Q3 | 11070.75 |
| 95-th percentile | 44379.5 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5615.75 |
Descriptive statistics
| Standard deviation | 41957.99892 |
|---|---|
| Coefficient of variation (CV) | 2.6657607 |
| Kurtosis | 295.395126 |
| Mean | 15739.59693 |
| Median Absolute Deviation (MAD) | 2702.5 |
| Skewness | 13.1911913 |
| Sum | 261434705 |
| Variance | 1760473673 |
| Value | Count | Frequency (%) | |
| 5000 | 285 | 1.7% | |
| 6000 | 225 | 1.4% | |
| 4000 | 183 | 1.1% | |
| 7200 | 177 | 1.1% | |
| 7500 | 105 | 0.6% | |
| 9600 | 93 | 0.6% | |
| 8400 | 90 | 0.5% | |
| 4500 | 89 | 0.5% | |
| 4800 | 89 | 0.5% | |
| 9000 | 76 | 0.5% | |
| Other values (8054) | 15198 | 91.5% |
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 572 | 1 | < 0.1% | |
| 600 | 1 | < 0.1% | |
| 609 | 1 | < 0.1% | |
| 649 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1651359 | 1 | < 0.1% | |
| 1074218 | 1 | < 0.1% | |
| 1024068 | 1 | < 0.1% | |
| 982998 | 1 | < 0.1% | |
| 982278 | 1 | < 0.1% |
floors
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4324503311258279 |
|---|---|
| Minimum | 1.0 |
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5096580185 |
|---|---|
| Coefficient of variation (CV) | 0.3557945483 |
| Kurtosis | -0.5415793027 |
| Mean | 1.432450331 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.6923517377 |
| Sum | 23793 |
| Variance | 0.2597512958 |
| Value | Count | Frequency (%) | |
| 1 | 8960 | 53.9% | |
| 2 | 5679 | 34.2% | |
| 1.5 | 1592 | 9.6% | |
| 3 | 269 | 1.6% | |
| 2.5 | 105 | 0.6% | |
| 3.5 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 8960 | 53.9% | |
| 1.5 | 1592 | 9.6% | |
| 2 | 5679 | 34.2% | |
| 2.5 | 105 | 0.6% | |
| 3 | 269 | 1.6% |
| Value | Count | Frequency (%) | |
| 3.5 | 5 | < 0.1% | |
| 3 | 269 | 1.6% | |
| 2.5 | 105 | 0.6% | |
| 2 | 5679 | 34.2% | |
| 1.5 | 1592 | 9.6% |
waterfront
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 129.8 KiB |
| 0 | |
|---|---|
| 1 | 132 |
| Value | Count | Frequency (%) | |
| 0 | 16478 | 99.2% | |
| 1 | 132 | 0.8% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.24388922335942204 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 14914 |
| Zeros (%) | 89.8% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7814686712 |
|---|---|
| Coefficient of variation (CV) | 3.204195169 |
| Kurtosis | 10.32891579 |
| Mean | 0.2438892234 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.318248224 |
| Sum | 4051 |
| Variance | 0.6106932841 |
| Value | Count | Frequency (%) | |
| 0 | 14914 | 89.8% | |
| 2 | 765 | 4.6% | |
| 3 | 405 | 2.4% | |
| 1 | 266 | 1.6% | |
| 4 | 260 | 1.6% |
| Value | Count | Frequency (%) | |
| 0 | 14914 | 89.8% | |
| 1 | 266 | 1.6% | |
| 2 | 765 | 4.6% | |
| 3 | 405 | 2.4% | |
| 4 | 260 | 1.6% |
| Value | Count | Frequency (%) | |
| 4 | 260 | 1.6% | |
| 3 | 405 | 2.4% | |
| 2 | 765 | 4.6% | |
| 1 | 266 | 1.6% | |
| 0 | 14914 | 89.8% |
condition
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4497290788681516 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.6666100385 |
|---|---|
| Coefficient of variation (CV) | 0.1932354754 |
| Kurtosis | 0.2145281474 |
| Mean | 3.449729079 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.897160679 |
| Sum | 57300 |
| Variance | 0.4443689434 |
| Value | Count | Frequency (%) | |
| 3 | 10214 | 61.5% | |
| 4 | 4807 | 28.9% | |
| 5 | 1425 | 8.6% | |
| 2 | 141 | 0.8% | |
| 1 | 23 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 23 | 0.1% | |
| 2 | 141 | 0.8% | |
| 3 | 10214 | 61.5% | |
| 4 | 4807 | 28.9% | |
| 5 | 1425 | 8.6% |
| Value | Count | Frequency (%) | |
| 5 | 1425 | 8.6% | |
| 4 | 4807 | 28.9% | |
| 3 | 10214 | 61.5% | |
| 2 | 141 | 0.8% | |
| 1 | 23 | 0.1% |
grade
Real number (ℝ≥0)
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.592414208308248 |
|---|---|
| Minimum | 3 |
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.168418697 |
|---|---|
| Coefficient of variation (CV) | 0.1538929074 |
| Kurtosis | 1.424443286 |
| Mean | 7.592414208 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.859343715 |
| Sum | 126110 |
| Variance | 1.365202251 |
| Value | Count | Frequency (%) | |
| 7 | 7278 | 43.8% | |
| 8 | 4411 | 26.6% | |
| 9 | 1814 | 10.9% | |
| 6 | 1706 | 10.3% | |
| 10 | 802 | 4.8% | |
| 11 | 287 | 1.7% | |
| 5 | 200 | 1.2% | |
| 12 | 73 | 0.4% | |
| 4 | 24 | 0.1% | |
| 13 | 12 | 0.1% |
| Value | Count | Frequency (%) | |
| 3 | 3 | < 0.1% | |
| 4 | 24 | 0.1% | |
| 5 | 200 | 1.2% | |
| 6 | 1706 | 10.3% | |
| 7 | 7278 | 43.8% |
| Value | Count | Frequency (%) | |
| 13 | 12 | 0.1% | |
| 12 | 73 | 0.4% | |
| 11 | 287 | 1.7% | |
| 10 | 802 | 4.8% | |
| 9 | 1814 | 10.9% |
sqft_above
Real number (ℝ≥0)
| Distinct count | 710 |
|---|---|
| Unique (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1750.221733895244 |
|---|---|
| Minimum | 370 |
| Maximum | 9410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 840 |
| Q1 | 1180 |
| median | 1530 |
| Q3 | 2140 |
| 95-th percentile | 3310 |
| Maximum | 9410 |
| Range | 9040 |
| Interquartile range (IQR) | 960 |
Descriptive statistics
| Standard deviation | 804.7895581 |
|---|---|
| Coefficient of variation (CV) | 0.4598214858 |
| Kurtosis | 4.075936661 |
| Mean | 1750.221734 |
| Median Absolute Deviation (MAD) | 430 |
| Skewness | 1.5530449 |
| Sum | 29071183 |
| Variance | 647686.2329 |
| Value | Count | Frequency (%) | |
| 1010 | 176 | 1.1% | |
| 1300 | 174 | 1.0% | |
| 1200 | 165 | 1.0% | |
| 1220 | 151 | 0.9% | |
| 1400 | 147 | 0.9% | |
| 1340 | 145 | 0.9% | |
| 1250 | 143 | 0.9% | |
| 1140 | 141 | 0.8% | |
| 1060 | 138 | 0.8% | |
| 1180 | 138 | 0.8% | |
| Other values (700) | 15092 | 90.9% |
| Value | Count | Frequency (%) | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 390 | 1 | < 0.1% | |
| 410 | 1 | < 0.1% | |
| 420 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9410 | 1 | < 0.1% | |
| 8860 | 1 | < 0.1% | |
| 8570 | 1 | < 0.1% | |
| 7880 | 1 | < 0.1% | |
| 7680 | 1 | < 0.1% |
| Distinct count | 271 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 303.6623720650211 |
|---|---|
| Minimum | 0 |
| Maximum | 4820 |
| Zeros | 9959 |
| Zeros (%) | 60.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 600 |
| 95-th percentile | 1200 |
| Maximum | 4820 |
| Range | 4820 |
| Interquartile range (IQR) | 600 |
Descriptive statistics
| Standard deviation | 450.7357924 |
|---|---|
| Coefficient of variation (CV) | 1.484332054 |
| Kurtosis | 2.712912315 |
| Mean | 303.6623721 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.537486622 |
| Sum | 5043832 |
| Variance | 203162.7546 |
| Value | Count | Frequency (%) | |
| 0 | 9959 | 60.0% | |
| 500 | 189 | 1.1% | |
| 700 | 185 | 1.1% | |
| 800 | 177 | 1.1% | |
| 600 | 171 | 1.0% | |
| 400 | 152 | 0.9% | |
| 1000 | 120 | 0.7% | |
| 900 | 119 | 0.7% | |
| 300 | 107 | 0.6% | |
| 530 | 86 | 0.5% | |
| Other values (261) | 5345 | 32.2% |
| Value | Count | Frequency (%) | |
| 0 | 9959 | 60.0% | |
| 40 | 2 | < 0.1% | |
| 50 | 6 | < 0.1% | |
| 60 | 8 | < 0.1% | |
| 70 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4820 | 1 | < 0.1% | |
| 4130 | 1 | < 0.1% | |
| 3500 | 1 | < 0.1% | |
| 3480 | 1 | < 0.1% | |
| 3260 | 1 | < 0.1% |
yr_built
Real number (ℝ≥0)
| Distinct count | 116 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1967.2948223961469 |
|---|---|
| Minimum | 1900 |
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1914 |
| Q1 | 1950 |
| median | 1969 |
| Q3 | 1990 |
| 95-th percentile | 2005 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 27.93517441 |
|---|---|
| Coefficient of variation (CV) | 0.01419979054 |
| Kurtosis | -0.6049668121 |
| Mean | 1967.294822 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | -0.4591374584 |
| Sum | 32676767 |
| Variance | 780.3739692 |
| Value | Count | Frequency (%) | |
| 1977 | 344 | 2.1% | |
| 2004 | 344 | 2.1% | |
| 2003 | 339 | 2.0% | |
| 1978 | 329 | 2.0% | |
| 1968 | 323 | 1.9% | |
| 1967 | 295 | 1.8% | |
| 2005 | 290 | 1.7% | |
| 1959 | 288 | 1.7% | |
| 1979 | 288 | 1.7% | |
| 1990 | 274 | 1.6% | |
| Other values (106) | 13496 | 81.3% |
| Value | Count | Frequency (%) | |
| 1900 | 74 | 0.4% | |
| 1901 | 25 | 0.2% | |
| 1902 | 23 | 0.1% | |
| 1903 | 33 | 0.2% | |
| 1904 | 40 | 0.2% |
| Value | Count | Frequency (%) | |
| 2015 | 10 | 0.1% | |
| 2014 | 104 | 0.6% | |
| 2013 | 32 | 0.2% | |
| 2012 | 32 | 0.2% | |
| 2011 | 27 | 0.2% |
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.75225767609874 |
|---|---|
| Minimum | 0 |
| Maximum | 2015 |
| Zeros | 15863 |
| Zeros (%) | 95.5% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 2015 |
| Range | 2015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 413.6230914 |
|---|---|
| Coefficient of variation (CV) | 4.608497904 |
| Kurtosis | 17.29380256 |
| Mean | 89.75225768 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.392066465 |
| Sum | 1490785 |
| Variance | 171084.0617 |
| Value | Count | Frequency (%) | |
| 0 | 15863 | 95.5% | |
| 2014 | 78 | 0.5% | |
| 2003 | 32 | 0.2% | |
| 2005 | 30 | 0.2% | |
| 2013 | 28 | 0.2% | |
| 2000 | 28 | 0.2% | |
| 1990 | 24 | 0.1% | |
| 2007 | 24 | 0.1% | |
| 2004 | 23 | 0.1% | |
| 2002 | 20 | 0.1% | |
| Other values (60) | 460 | 2.8% |
| Value | Count | Frequency (%) | |
| 0 | 15863 | 95.5% | |
| 1934 | 1 | < 0.1% | |
| 1940 | 2 | < 0.1% | |
| 1944 | 1 | < 0.1% | |
| 1945 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2015 | 13 | 0.1% | |
| 2014 | 78 | 0.5% | |
| 2013 | 28 | 0.2% | |
| 2012 | 9 | 0.1% | |
| 2011 | 11 | 0.1% |
zipcode
Real number (ℝ≥0)
| Distinct count | 70 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98078.16520168573 |
|---|---|
| Minimum | 98001 |
| Maximum | 98199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 98001 |
|---|---|
| 5-th percentile | 98004 |
| Q1 | 98033 |
| median | 98065 |
| Q3 | 98118 |
| 95-th percentile | 98177 |
| Maximum | 98199 |
| Range | 198 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 54.15373311 |
|---|---|
| Coefficient of variation (CV) | 0.0005521487173 |
| Kurtosis | -0.8790295035 |
| Mean | 98078.1652 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 0.4089065237 |
| Sum | 1629078324 |
| Variance | 2932.62681 |
| Value | Count | Frequency (%) | |
| 98052 | 457 | 2.8% | |
| 98038 | 456 | 2.7% | |
| 98115 | 455 | 2.7% | |
| 98034 | 438 | 2.6% | |
| 98117 | 422 | 2.5% | |
| 98042 | 418 | 2.5% | |
| 98103 | 412 | 2.5% | |
| 98023 | 408 | 2.5% | |
| 98006 | 400 | 2.4% | |
| 98133 | 399 | 2.4% | |
| Other values (60) | 12345 | 74.3% |
| Value | Count | Frequency (%) | |
| 98001 | 266 | 1.6% | |
| 98002 | 145 | 0.9% | |
| 98003 | 230 | 1.4% | |
| 98004 | 245 | 1.5% | |
| 98005 | 151 | 0.9% |
| Value | Count | Frequency (%) | |
| 98199 | 243 | 1.5% | |
| 98198 | 230 | 1.4% | |
| 98188 | 117 | 0.7% | |
| 98178 | 221 | 1.3% | |
| 98177 | 205 | 1.2% |
lat
Real number (ℝ≥0)
| Distinct count | 4833 |
|---|---|
| Unique (%) | 29.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.56002361228176 |
|---|---|
| Minimum | 47.1559 |
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3102 |
| Q1 | 47.4646 |
| median | 47.573 |
| Q3 | 47.679075 |
| 95-th percentile | 47.7508 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.214475 |
Descriptive statistics
| Standard deviation | 0.1397186585 |
|---|---|
| Coefficient of variation (CV) | 0.002937733162 |
| Kurtosis | -0.7208026492 |
| Mean | 47.56002361 |
| Median Absolute Deviation (MAD) | 0.1067 |
| Skewness | -0.4691442717 |
| Sum | 789971.9922 |
| Variance | 0.01952130354 |
| Value | Count | Frequency (%) | |
| 47.6711 | 15 | 0.1% | |
| 47.6624 | 14 | 0.1% | |
| 47.6955 | 13 | 0.1% | |
| 47.5427 | 13 | 0.1% | |
| 47.5305 | 12 | 0.1% | |
| 47.6388 | 12 | 0.1% | |
| 47.697 | 12 | 0.1% | |
| 47.5518 | 12 | 0.1% | |
| 47.686 | 12 | 0.1% | |
| 47.5521 | 11 | 0.1% | |
| Other values (4823) | 16484 | 99.2% |
| Value | Count | Frequency (%) | |
| 47.1559 | 1 | < 0.1% | |
| 47.1593 | 1 | < 0.1% | |
| 47.1622 | 1 | < 0.1% | |
| 47.1647 | 1 | < 0.1% | |
| 47.1764 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 47.7776 | 2 | < 0.1% | |
| 47.7775 | 3 | < 0.1% | |
| 47.7774 | 1 | < 0.1% | |
| 47.7772 | 2 | < 0.1% | |
| 47.7771 | 1 | < 0.1% |
long
Real number (ℝ)
| Distinct count | 729 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.2153820590006 |
|---|---|
| Minimum | -122.519 |
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.327 |
| median | -122.231 |
| Q3 | -122.12725 |
| 95-th percentile | -121.98545 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.19975 |
Descriptive statistics
| Standard deviation | 0.1386610324 |
|---|---|
| Coefficient of variation (CV) | -0.001134562852 |
| Kurtosis | 1.179309129 |
| Mean | -122.2153821 |
| Median Absolute Deviation (MAD) | 0.099 |
| Skewness | 0.8915388217 |
| Sum | -2029997.496 |
| Variance | 0.0192268819 |
| Value | Count | Frequency (%) | |
| -122.29 | 95 | 0.6% | |
| -122.3 | 89 | 0.5% | |
| -122.306 | 78 | 0.5% | |
| -122.288 | 78 | 0.5% | |
| -122.372 | 77 | 0.5% | |
| -122.316 | 76 | 0.5% | |
| -122.351 | 76 | 0.5% | |
| -122.291 | 76 | 0.5% | |
| -122.172 | 75 | 0.5% | |
| -122.299 | 73 | 0.4% | |
| Other values (719) | 15817 | 95.2% |
| Value | Count | Frequency (%) | |
| -122.519 | 1 | < 0.1% | |
| -122.515 | 1 | < 0.1% | |
| -122.514 | 1 | < 0.1% | |
| -122.512 | 1 | < 0.1% | |
| -122.511 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| -121.315 | 2 | < 0.1% | |
| -121.316 | 1 | < 0.1% | |
| -121.319 | 1 | < 0.1% | |
| -121.321 | 1 | < 0.1% | |
| -121.325 | 1 | < 0.1% |
sqft_living15
Real number (ℝ≥0)
| Distinct count | 621 |
|---|---|
| Unique (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1974.796447922938 |
|---|---|
| Minimum | 399 |
| Maximum | 6110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| median | 1830 |
| Q3 | 2330 |
| 95-th percentile | 3260 |
| Maximum | 6110 |
| Range | 5711 |
| Interquartile range (IQR) | 840 |
Descriptive statistics
| Standard deviation | 673.0288617 |
|---|---|
| Coefficient of variation (CV) | 0.3408092325 |
| Kurtosis | 1.655339029 |
| Mean | 1974.796448 |
| Median Absolute Deviation (MAD) | 400 |
| Skewness | 1.114691539 |
| Sum | 32801369 |
| Variance | 452967.8487 |
| Value | Count | Frequency (%) | |
| 1540 | 161 | 1.0% | |
| 1560 | 159 | 1.0% | |
| 1440 | 148 | 0.9% | |
| 1500 | 140 | 0.8% | |
| 1610 | 134 | 0.8% | |
| 1460 | 133 | 0.8% | |
| 1660 | 132 | 0.8% | |
| 1510 | 129 | 0.8% | |
| 1620 | 129 | 0.8% | |
| 1480 | 128 | 0.8% | |
| Other values (611) | 15217 | 91.6% |
| Value | Count | Frequency (%) | |
| 399 | 1 | < 0.1% | |
| 460 | 1 | < 0.1% | |
| 620 | 1 | < 0.1% | |
| 700 | 1 | < 0.1% | |
| 710 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6110 | 1 | < 0.1% | |
| 5790 | 3 | < 0.1% | |
| 5610 | 1 | < 0.1% | |
| 5600 | 1 | < 0.1% | |
| 5500 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ≥0)
| Distinct count | 7282 |
|---|---|
| Unique (%) | 43.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13288.307224563516 |
|---|---|
| Minimum | 660 |
| Maximum | 871200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 129.8 KiB |
Quantile statistics
| Minimum | 660 |
|---|---|
| 5-th percentile | 3060 |
| Q1 | 5421.5 |
| median | 7823 |
| Q3 | 10326 |
| 95-th percentile | 38092.9 |
| Maximum | 871200 |
| Range | 870540 |
| Interquartile range (IQR) | 4904.5 |
Descriptive statistics
| Standard deviation | 27458.70054 |
|---|---|
| Coefficient of variation (CV) | 2.066380621 |
| Kurtosis | 122.8017425 |
| Mean | 13288.30722 |
| Median Absolute Deviation (MAD) | 2423 |
| Skewness | 8.761807766 |
| Sum | 220718783 |
| Variance | 753980235.3 |
| Value | Count | Frequency (%) | |
| 5000 | 337 | 2.0% | |
| 4000 | 288 | 1.7% | |
| 6000 | 219 | 1.3% | |
| 7200 | 167 | 1.0% | |
| 7500 | 124 | 0.7% | |
| 4800 | 104 | 0.6% | |
| 8400 | 91 | 0.5% | |
| 8000 | 91 | 0.5% | |
| 5100 | 88 | 0.5% | |
| 4080 | 84 | 0.5% | |
| Other values (7272) | 15017 | 90.4% |
| Value | Count | Frequency (%) | |
| 660 | 1 | < 0.1% | |
| 887 | 1 | < 0.1% | |
| 928 | 1 | < 0.1% | |
| 955 | 1 | < 0.1% | |
| 972 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 871200 | 1 | < 0.1% | |
| 560617 | 1 | < 0.1% | |
| 438213 | 1 | < 0.1% | |
| 434728 | 1 | < 0.1% | |
| 425581 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 221900.0 | 3 | 1.00 | 1180 | 5650 | 1.0 | 0 | 0 | 3 | 7 | 1180 | 0 | 1955 | 0 | 98178 | 47.5112 | -122.257 | 1340 | 5650 |
| 1 | 1 | 538000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | 0 | 0 | 3 | 7 | 2170 | 400 | 1951 | 1991 | 98125 | 47.7210 | -122.319 | 1690 | 7639 |
| 2 | 2 | 180000.0 | 2 | 1.00 | 770 | 10000 | 1.0 | 0 | 0 | 3 | 6 | 770 | 0 | 1933 | 0 | 98028 | 47.7379 | -122.233 | 2720 | 8062 |
| 3 | 3 | 604000.0 | 4 | 3.00 | 1960 | 5000 | 1.0 | 0 | 0 | 5 | 7 | 1050 | 910 | 1965 | 0 | 98136 | 47.5208 | -122.393 | 1360 | 5000 |
| 4 | 4 | 510000.0 | 3 | 2.00 | 1680 | 8080 | 1.0 | 0 | 0 | 3 | 8 | 1680 | 0 | 1987 | 0 | 98074 | 47.6168 | -122.045 | 1800 | 7503 |
| 5 | 5 | 1225000.0 | 4 | 4.50 | 5420 | 101930 | 1.0 | 0 | 0 | 3 | 11 | 3890 | 1530 | 2001 | 0 | 98053 | 47.6561 | -122.005 | 4760 | 101930 |
| 6 | 6 | 257500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | 0 | 0 | 3 | 7 | 1715 | 0 | 1995 | 0 | 98003 | 47.3097 | -122.327 | 2238 | 6819 |
| 7 | 7 | 291850.0 | 3 | 1.50 | 1060 | 9711 | 1.0 | 0 | 0 | 3 | 7 | 1060 | 0 | 1963 | 0 | 98198 | 47.4095 | -122.315 | 1650 | 9711 |
| 8 | 8 | 229500.0 | 3 | 1.00 | 1780 | 7470 | 1.0 | 0 | 0 | 3 | 7 | 1050 | 730 | 1960 | 0 | 98146 | 47.5123 | -122.337 | 1780 | 8113 |
| 9 | 9 | 323000.0 | 3 | 2.50 | 1890 | 6560 | 2.0 | 0 | 0 | 3 | 7 | 1890 | 0 | 2003 | 0 | 98038 | 47.3684 | -122.031 | 2390 | 7570 |
Last rows
| df_index | price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | yr_built | yr_renovated | zipcode | lat | long | sqft_living15 | sqft_lot15 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16600 | 16603 | 225000.0 | 2 | 1.00 | 910 | 9612 | 1.0 | 0 | 0 | 4 | 7 | 910 | 0 | 1981 | 0 | 98058 | 47.4297 | -122.152 | 1410 | 9611 |
| 16601 | 16604 | 250000.0 | 3 | 1.00 | 1460 | 10914 | 1.0 | 0 | 0 | 4 | 7 | 1460 | 0 | 1959 | 0 | 98058 | 47.4511 | -122.173 | 1490 | 8314 |
| 16602 | 16605 | 585000.0 | 4 | 3.25 | 3410 | 34939 | 2.0 | 0 | 0 | 4 | 9 | 2470 | 940 | 1992 | 0 | 98027 | 47.4590 | -122.003 | 2450 | 39045 |
| 16603 | 16606 | 685000.0 | 3 | 1.75 | 2720 | 4720 | 1.5 | 0 | 0 | 4 | 7 | 1580 | 1140 | 1925 | 0 | 98105 | 47.6691 | -122.290 | 1660 | 4640 |
| 16604 | 16607 | 420000.0 | 5 | 2.75 | 2280 | 10319 | 1.0 | 0 | 0 | 3 | 8 | 1300 | 980 | 1959 | 0 | 98177 | 47.7566 | -122.363 | 2370 | 8056 |
| 16605 | 16608 | 245000.0 | 2 | 1.00 | 670 | 1675 | 1.0 | 0 | 0 | 5 | 6 | 670 | 0 | 1960 | 0 | 98144 | 47.5918 | -122.295 | 1220 | 1740 |
| 16606 | 16609 | 275000.0 | 4 | 2.00 | 1480 | 15000 | 1.0 | 0 | 0 | 4 | 7 | 1480 | 0 | 1957 | 0 | 98055 | 47.4312 | -122.196 | 1450 | 8768 |
| 16607 | 16610 | 270000.0 | 3 | 2.00 | 2330 | 8000 | 1.0 | 0 | 0 | 3 | 7 | 1390 | 940 | 1986 | 0 | 98023 | 47.2958 | -122.368 | 1570 | 7227 |
| 16608 | 16611 | 767250.0 | 4 | 3.00 | 2170 | 2500 | 2.0 | 0 | 0 | 3 | 8 | 1710 | 460 | 1997 | 0 | 98115 | 47.6742 | -122.303 | 2170 | 4080 |
| 16609 | 16612 | 229000.0 | 3 | 2.00 | 1760 | 9900 | 1.0 | 0 | 0 | 4 | 7 | 1760 | 0 | 1943 | 0 | 98166 | 47.4783 | -122.338 | 1190 | 9900 |